SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_ShowCompanys]
	
	(
	@param_recruitment INT 

	)
	
AS
	/* SET NOCOUNT ON */
	SELECT JOL_Employer_Name, id
	FROM dbo.JOL_Recruitment_Participants_apply,dbo.JOL_Employer
	WHERE employing_unit=JOL_Employer_No AND recruitment=@param_recruitment
	ORDER BY JOL_Employer_Name
	RETURN
GO
